package com.show.dao.sys_emp;

import com.show.dto.sys_emp.SysEmpRole;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;

/**
 * Created by yxd on 2018/2/5.
 */
public interface EmpRoleRespository extends JpaRepository<SysEmpRole, String>, JpaSpecificationExecutor<SysEmpRole> {

    @Modifying
    @Query(value = " delete from sys_emp_role  where emp_id=?1 ", nativeQuery = true)
    void deleteByEmpId(int emp_id);
}
